D:\TICS-2021-1\ProyectoMarisol\heat_maps\lib\site-packages\IPython\core\interactiveshell.py:2714: DtypeWarning: Columns (0,2,6,12) have mixed types.Specify dtype option on import or set low_memory=False. interactivity=interactivity, compiler=compiler, result=result)
| INCIDENT_NUMBER | OFFENSE_CODE | OFFENSE_CODE_GROUP | OFFENSE_DESCRIPTION | DISTRICT | REPORTING_AREA | SHOOTING | OCCURRED_ON_DATE | YEAR | MONTH | DAY_OF_WEEK | HOUR | UCR_PART | STREET | Lat | Long | Location | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | TESTTEST2 | 423 | NaN | ASSAULT - AGGRAVATED | External | 0 | 2019-10-16 00:00:00 | 2019 | 10 | Wednesday | 0 | NaN | RIVERVIEW DR | NaN | NaN | (0.00000000, 0.00000000) | |
| 1 | S97333701 | 3301 | NaN | VERBAL DISPUTE | C6 | 915 | 0 | 2020-07-18 14:34:00 | 2020 | 7 | Saturday | 14 | NaN | MARY BOYLE WAY | 42.330813 | -71.051368 | (42.33081300, -71.05136800) |
| 2 | S47513131 | 2647 | NaN | THREATS TO DO BODILY HARM | E18 | 530 | 0 | 2020-06-24 10:15:00 | 2020 | 6 | Wednesday | 10 | NaN | READVILLE ST | 42.239491 | -71.135954 | (42.23949100, -71.13595400) |
(10000, 17)
Las líneas de abajo, tardaron varios minutos en correr y se comieron algunas gigas de RAM.
| DISTRICT | STREET | REPORTING_AREA | Lat | Long | OFFENSE_CODE | YEAR | MONTH | HOUR | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | A1 | ALBANY ST | 172 | 42.334288 | -71.072395 | 1857 | 6057 | 26 | 45 |
| 1 | A1 | ANDERSON ST | 66 | 42.360028 | -71.067768 | 6611 | 4038 | 16 | 20 |
| 2 | A1 | ANDERSON ST | 66 | 42.360802 | -71.067828 | 802 | 2019 | 9 | 1 |
| 3 | A1 | ANDERSON ST | 67 | 42.360028 | -71.067768 | 617 | 2019 | 9 | 20 |
| 4 | A1 | ARCH ST | 106 | 42.354874 | -71.058612 | 3006 | 2019 | 9 | 10 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 4770 | E5 | WILKINS PL | 560 | 42.283260 | -71.127404 | 802 | 2019 | 9 | 10 |
| 4771 | E5 | WILLERS ST | 822 | 42.259680 | -71.150376 | 3112 | 2019 | 8 | 19 |
| 4772 | E5 | WILNA CT | 696 | 42.288515 | -71.153326 | 3114 | 2019 | 9 | 16 |
| 4773 | E5 | WINTON ST | 550 | 42.275022 | -71.133620 | 3802 | 2019 | 9 | 14 |
| 4774 | E5 | WREN ST | 702 | 42.281813 | -71.152631 | 1102 | 2019 | 8 | 10 |
4775 rows × 9 columns
| DISTRICT | STREET | REPORTING_AREA | Lat | Long | OFFENSE_CODE | YEAR | MONTH | HOUR | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | District:A1 | ALBANY ST | Reports:172 | 42.334288 | -71.072395 | 1857 | 6057 | 26 | 45 |
| 1 | District:A1 | ANDERSON ST | Reports:66 | 42.360028 | -71.067768 | 6611 | 4038 | 16 | 20 |
| 2 | District:A1 | ANDERSON ST | Reports:66 | 42.360802 | -71.067828 | 802 | 2019 | 9 | 1 |
| 3 | District:A1 | ANDERSON ST | Reports:67 | 42.360028 | -71.067768 | 617 | 2019 | 9 | 20 |
| 4 | District:A1 | ARCH ST | Reports:106 | 42.354874 | -71.058612 | 3006 | 2019 | 9 | 10 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 4770 | District:E5 | WILKINS PL | Reports:560 | 42.283260 | -71.127404 | 802 | 2019 | 9 | 10 |
| 4771 | District:E5 | WILLERS ST | Reports:822 | 42.259680 | -71.150376 | 3112 | 2019 | 8 | 19 |
| 4772 | District:E5 | WILNA CT | Reports:696 | 42.288515 | -71.153326 | 3114 | 2019 | 9 | 16 |
| 4773 | District:E5 | WINTON ST | Reports:550 | 42.275022 | -71.133620 | 3802 | 2019 | 9 | 14 |
| 4774 | District:E5 | WREN ST | Reports:702 | 42.281813 | -71.152631 | 1102 | 2019 | 8 | 10 |
4775 rows × 9 columns
<seaborn.axisgrid.FacetGrid at 0x1faae72f988>